I've noticed the following....

Create a sheet with the values below and enable the "Filter" option on this table.
(I've added the row-numbers on the left, to later show the filter in action)

(1) col1 col2
(2) a 1
(3) a 2
(4) a 3

Using the filter option on the col2 column, unmark value "2".
This is an essential step, since the bug only appears when hiding rows -in between- of other rows.
Hiding 1 or 3 will not have the same result.
You table should now look like this. Notice row (3) is hidden, as it should be:

(1) col1 col2
(2) a 1
(4) a 3

Now type "b" in a random empty cell, select the cell (not the value), and copy it.

Now, and this is an essential step, click down on the "a" value on row (2), keeping your mouse pressed, drag to the "a" value on row (4),  so that both cells are selected with one selection box, not two separate boxes.

Within this selection box, right-mouse click, and select "Paste Special -> Values" NOT "Paste Special -> Paste".

Now use the filter to unhide value "2". You table should/will look like this:

(1) col1 col2
(2) b 1
(3) b 2
(4) b 3

This is -not- the expected behavious, when using "Paste Special -> Paste", the result is as expected:

(1) col1 col2
(2) b 1
(3) a 2
(4) b 3

This issue is also present in Excel 2010, and i've tested this on various computers.

• Edited by Wouter1231 Wednesday, April 29, 2015 1:27 PM

This is not a bug. You have left out some steps to select the visible cells and hence you nave selected the entire range A2:A4 and that is why it pasted to the entire range.

Set the filter as per your description (uncheck 2)

Type the letter b in another cell and copy the cell.

Click the cell with "a" value in cell A2 and drag down to A4 (this actually select entire range A2:A4).

Select Find & Select (far right of Home ribbon) -> Go to Special.

In the dialog select option Visible cells only and OK.

Now Right click over one of the selected cells and Paste Special -> Values.